Tabela TNMDependency

Definicja tabeli TNMDependency

Name

TNMDependency

Code

TNMDependency

Comment

Informacje o zaleznosciach ICD, T, N, M, Stopien zaawansowania


Lista kolumn tabeli TNMDependency

Name

Code

TNMDependencyID

TNMDependencyID

ICDCode

ICDCode

TNMTumourID

TNMTumourID

TNMNodusID

TNMNodusID

TNMMetastasesID

TNMMetastasesID

TumourAdvancedLevelID

TumourAdvancedLevelID

TSequenceNo

TSequenceNo

NSequenceNo

NSequenceNo

MSequenceNo

MSequenceNo


Kolumna TNMDependencyID tabeli TNMDependency

Definicja kolumny TNMDependencyID tabeli TNMDependency

Name

TNMDependencyID

Code

TNMDependencyID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID informacji o zaleznosci ICD


Kolumna ICDCode tabeli TNMDependency

Definicja kolumny ICDCode tabeli TNMDependency

Name

ICDCode

Code

ICDCode

Data Type

VARCHAR2(5)

Mandatory

Yes

Comment

kod ICD10


Kolumna TNMTumourID tabeli TNMDependency

Definicja kolumny TNMTumourID tabeli TNMDependency

Name

TNMTumourID

Code

TNMTumourID

Data Type

NUMBER(10)

Mandatory

No

Comment

kod T, ze slownika TNMTumour


Kolumna TNMNodusID tabeli TNMDependency

Definicja kolumny TNMNodusID tabeli TNMDependency

Name

TNMNodusID

Code

TNMNodusID

Data Type

NUMBER(10)

Mandatory

No

Comment

kod N, ze slownika TNMNodus


Kolumna TNMMetastasesID tabeli TNMDependency

Definicja kolumny TNMMetastasesID tabeli TNMDependency

Name

TNMMetastasesID

Code

TNMMetastasesID

Data Type

NUMBER(10)

Mandatory

No

Comment

kod M, ze slownika TNMMetastases


Kolumna TumourAdvancedLevelID tabeli TNMDependency

Definicja kolumny TumourAdvancedLevelID tabeli TNMDependency

Name

TumourAdvancedLevelID

Code

TumourAdvancedLevelID

Data Type

NUMBER(10)

Mandatory

No

Comment

stopien zaawansowania. Slownik w DictionaryValue


Kolumna TSequenceNo tabeli TNMDependency

Definicja kolumny TSequenceNo tabeli TNMDependency

Name

TSequenceNo

Code

TSequenceNo

Data Type

NUMBER(10)

Mandatory

No

Comment

kolejnosc kodu T w ramach diagnozy


Kolumna NSequenceNo tabeli TNMDependency

Definicja kolumny NSequenceNo tabeli TNMDependency

Name

NSequenceNo

Code

NSequenceNo

Data Type

NUMBER(10)

Mandatory

No

Comment

kolejnosc kodu N w ramach T


Kolumna MSequenceNo tabeli TNMDependency

Definicja kolumny MSequenceNo tabeli TNMDependency

Name

MSequenceNo

Code

MSequenceNo

Data Type

NUMBER(10)

Mandatory

No

Comment

kolejnosc kodu M w ramach M


Lista kluczy tabeli TNMDependency

Name

Code

Primary

PK_LICDTNMTumour

PK_LICDTNMTumour

X


Klucz PK_LICDTNMTumour tabeli TNMDependency

Definicja klucza PK_LICDTNMTumour tabeli TNMDependency

Name

PK_LICDTNMTumour

Code

PK_LICDTNMTumour

Primary

Yes

Comment